<%--
  Created by IntelliJ IDEA.
  User: Gao
  Date: 2024/4/15
  Time: 14:17
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
    <link rel="stylesheet" href="static/layui/css/layui.css">
    <script src="/static/jquery-2.1.4.js" type="text/javascri
    pt" charset="utf-8"></script>
    <script src="/static/layui/layui.js" type="text/javascript" charset="utf-8"></script>
    <script src="/static/mylayer.js" type="text/javascript" charset="utf-8"></script>
</head>
<body>
<%--搜索form表单--%>
<form class="layui-form layui-row layui-col-space16">
    用户名：
    <div class="layui-inline layui-input-wrap">
        <div class="layui-input-prefix">
            <i class="layui-icon layui-icon-username"></i>
        </div>
        <input type="text" name="name" value="" class="layui-input" lay-affix="clear">
    </div>
    地址：
    <div class="layui-inline layui-input-wrap">
        <input type="text" name="address" lay-affix="clear" class="layui-input">
    </div>
    时间：
    <div class="layui-inline layui-input-wrap">
        <input type="text" name="time" lay-affix="clear" class="layui-input">
    </div>
    <div class="layui-inline">
        <button class="layui-btn" lay-submit lay-filter="submitSearch">Search</button>
        <button type="reset" class="layui-btn layui-btn-primary">Clear</button>
    </div>
</form>
<table class="layui-hide" id="test" lay-filter="test"></table>
<%--头部工具条--%>
<script id="toolbarDemo" type="text/html">
    <div class="layui-btn-container">
        <button class="layui-btn layui-btn-sm" lay-event="add">添加</button>
        <button class="layui-btn layui-btn-sm layui-btn-danger" lay-event="deleteAll">批量删除</button>
    </div>
</script>
<%--右侧工具栏--%>
<script type="text/html" id="barDemo">
    <div class="layui-clear-space">
        <a class="layui-btn layui-btn-xs layui-btn-danger" lay-event="delete">删除</a>
        <a class="layui-btn layui-btn-xs" lay-event="update">编辑</a>
    </div>
</script>
<%--添加form表单--%>
<div id="addForm" style="display:none;">
    <form class="layui-form" action="">
        <div class="layui-form-item">
            <label class="layui-form-label">班级名</label>
            <div class="layui-input-block">
                <input type="text" name="name" lay-verify="required" placeholder="请输入" autocomplete="off" class="layui-input">
            </div>
        </div>
        <div class="layui-form-item">
            <label class="layui-form-label">地址</label>
            <div class="layui-input-block">
                <input type="text" name="address" lay-verify="required" placeholder="请输入" autocomplete="off" class="layui-input">
            </div>
        </div>
        <div class="layui-form-item">
            <label class="layui-form-label">时间</label>
            <div class="layui-input-block">
                <input type="text" name="time" lay-verify="required" placeholder="请输入" autocomplete="off" class="layui-input">
            </div>
        </div>
        <div class="layui-form-item">
            <div class="layui-input-block">
                <button type="submit" class="layui-btn" lay-submit lay-filter="submitAdd">立即提交</button>
                <button type="reset" class="layui-btn layui-btn-primary">重置</button>
            </div>
        </div>
    </form>
</div>
<%--修改form表单--%>
<div id="updateForm" style="display:none;">
    <form class="layui-form" lay-filter="updateFormFilter" action="">
        <input type="hidden" name="id">
        <div class="layui-form-item">
            <label class="layui-form-label">班级名</label>
            <div class="layui-input-block">
                <input type="text" name="name" lay-verify="required" placeholder="请输入" autocomplete="off" class="layui-input">
            </div>
        </div>
        <div class="layui-form-item">
            <label class="layui-form-label">地址</label>
            <div class="layui-input-block">
                <input type="text" name="address" lay-verify="required" placeholder="请输入" autocomplete="off" class="layui-input">
            </div>
        </div>
        <div class="layui-form-item">
            <label class="layui-form-label">时间</label>
            <div class="layui-input-block">
                <input type="text" name="time" lay-verify="required" placeholder="请输入" autocomplete="off" class="layui-input">
            </div>
        </div>
        <div class="layui-form-item">
            <div class="layui-input-block">
                <button type="submit" class="layui-btn" lay-submit lay-filter="submitUpdate">立即提交</button>
                <button type="reset" class="layui-btn layui-btn-primary">重置</button>
            </div>
        </div>
    </form>
</div>

<script>
    layui.use(['table', 'form'], function(){
        var form = layui.form;
        var table = layui.table;
        // 创建渲染实例
        table.render({
            elem: '#test',
            id: 'tableId',
            url:'/banji?method=selectByPage',
            toolbar: '#toolbarDemo',
            cols: [[
                {type: 'checkbox', fixed: 'left'},
                {field:'id', title: 'ID', sort: true},
                {field:'name', title: '班级名'},
                {field:'address', title: '地址'},
                {field:'time', title: '入学时间', sort: true},
                {fixed: 'right', title:'操作', width: 134, minWidth: 125, toolbar: '#barDemo'}
            ]],
            page: true
        });

        // 搜索提交
        form.on('submit(submitSearch)', function(data){
            var field = data.field; // 获得表单字段
            // 执行搜索重载
            table.reload('tableId', {
                page: {
                    curr: 1 // 重新从第 1 页开始
                },
                where: field // 搜索的字段
                //http://localhost:8080/banji?method=selectByPage&page=1&limit=10&name=zhansgsan&address=5&time=2014
            });
            return false; // 阻止默认 form 跳转
        });

        // 头部工具栏事件
        table.on('toolbar(test)', function(obj){
            var id = obj.config.id;
            var checkStatus = table.checkStatus(id);
            var othis = lay(this);
            switch(obj.event){
                case 'add':
                    var index = layer.open({
                        type: 1,
                        title: '添加数据',
                        area: ['500px', '300px'], // 宽高
                        content: $('#addForm').html()
                    });

                    // 绑定提交事件
                    form.on('submit(submitAdd)', function(data){
                        var field = data.field; // 获取表单字段值
                        console.log(data);
                        // 此处可执行 Ajax 等操作
                        $.post(
                            '/banji?method=add',
                            field,  //{name: 'zhyangsan', address: 'fdfd', time: 'fd'}
                            function(result) {
                                console.log(result);
                                if (result.code == 0) {
                                    mylayer.okMsg(result.msg);
                                    layer.close(index);
                                    table.reload('tableId');
                                } else {
                                    mylayer.errorMsg(result.msg);
                                }
                            },
                            'json'
                        );
                        return false; // 阻止默认 form 跳转
                    });
                    break;
                case 'deleteAll':
                    var data = checkStatus.data;
                    //[{"id":2,"name":"Java1812","address":"ddf","time":"232"},{"id":3,"name":"Java1903","address":"34","time":"323"}]
                    var ids = new Array();
                    $(data).each(function () {
                        ids.push(this.id);
                    })
                    //[2,4]
                    layer.confirm(
                        '您确认要删除么?',
                        {icon : 3},
                        function(index){
                            $.post(
                                '/banji?method=deleteAll',
                                {'ids': ids},
                                function (result) {
                                    console.log(result);
                                    if (result.code == 0) {
                                        mylayer.okMsg(result.msg);
                                        //删除成功之后刷新表格，展示最新数据
                                        table.reload('tableId');
                                    } else {
                                        mylayer.errorMsg(result.msg);
                                    }
                                },
                                'json'
                            );
                        }
                    );
                    break;
                case 'LAYTABLE_TIPS':
                    layer.alert('自定义工具栏图标按钮');
                    break;
            };
        });

        // 触发单元格工具事件
        table.on('tool(test)', function(obj){ // 双击 toolDouble
            var data = obj.data; // 获得当前行数据
            console.log(obj);
            //{"id": 1,"name": "Java1807","address": "dfdf","time": "3434"}
            console.log(obj.data);
            if(obj.event === 'delete'){
                layer.confirm(
                    '您确认要删除么?',
                    {icon : 3},
                    function(index){
                        $.post(
                            '/banji?method=deleteById',
                            {'id': data.id},
                            function (result) {
                                console.log(result);
                                if (result.code == 0) {
                                    mylayer.okMsg(result.msg);
                                    //删除成功之后刷新表格，展示最新数据
                                    table.reload('tableId');
                                } else {
                                    mylayer.errorMsg(result.msg);
                                }
                            },
                            'json'
                        );
                    }
                );
            } else if(obj.event === 'update'){
                var index = layer.open({
                    type: 1,
                    title: '编辑数据',
                    area: ['500px', '300px'], // 宽高
                    content: $('#updateForm').html(),
                    success: function () {
                        //form.val有两个参数，第一个是form表单的lay-filter名字，
                        //第二个参数是json对象：{"id": 1,"name": "Java1807","address": "dfdf","time": "3434"}
                        //将第二个参数的值按照“名字”映射到form表单中
                        //form.val('updateFormFilter', data);
                        $.post(
                            '/banji?method=selectById',
                            {'id': data.id},
                            function (result) {
                                if (result.code == 0) {
                                    form.val('updateFormFilter', result.data);
                                }
                            },
                            'json'
                        );
                    }
                });

                // 绑定提交事件
                form.on('submit(submitUpdate)', function(data){
                    var field = data.field; // 获取表单字段值
                    console.log(data);
                    // 此处可执行 Ajax 等操作
                    $.post(
                        '/banji?method=update',
                        field,  //{name: 'zhyangsan', address: 'fdfd', time: 'fd'}
                        function(result) {
                            console.log(result);
                            if (result.code == 0) {
                                mylayer.okMsg(result.msg);
                                layer.close(index);
                                table.reload('tableId');
                            } else {
                                mylayer.errorMsg(result.msg);
                            }
                        },
                        'json'
                    );
                    return false; // 阻止默认 form 跳转
                });
            }
        });

    });
</script>
</body>
</html>